package com.ruoyi.organization.mapper;

import java.time.LocalDateTime;
import java.util.List;
import com.ruoyi.organization.domain.BizFamilyScoreLog;
import com.ruoyi.organization.domain.vo.CommunityScoreDto;
import org.apache.ibatis.annotations.Param;

/**
 * 家庭积分流水明细Mapper接口
 * 
 * @author ruoyi
 * @date 2024-07-04
 */
public interface BizFamilyScoreLogMapper 
{
    /**
     * 查询家庭积分流水明细
     * 
     * @param id 家庭积分流水明细主键
     * @return 家庭积分流水明细
     */
    public BizFamilyScoreLog selectBizFamilyScoreLogById(Long id);

    /**
     * 查询家庭积分流水明细列表
     * 
     * @param bizFamilyScoreLog 家庭积分流水明细
     * @return 家庭积分流水明细集合
     */
    public List<BizFamilyScoreLog> selectBizFamilyScoreLogList(BizFamilyScoreLog bizFamilyScoreLog);

    /**
     * 新增家庭积分流水明细
     * 
     * @param bizFamilyScoreLog 家庭积分流水明细
     * @return 结果
     */
    public int insertBizFamilyScoreLog(BizFamilyScoreLog bizFamilyScoreLog);

    /**
     * 修改家庭积分流水明细
     * 
     * @param bizFamilyScoreLog 家庭积分流水明细
     * @return 结果
     */
    public int updateBizFamilyScoreLog(BizFamilyScoreLog bizFamilyScoreLog);

    /**
     * 删除家庭积分流水明细
     * 
     * @param id 家庭积分流水明细主键
     * @return 结果
     */
    public int deleteBizFamilyScoreLogById(Long id);

    /**
     * 批量删除家庭积分流水明细
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteBizFamilyScoreLogByIds(Long[] ids);

    /**
     * 已发放的总积分
     * @return
     */
	Long sendTotal(@Param("orderScoreType")Integer type, @Param("start") LocalDateTime start, @Param("end") LocalDateTime end);
    Long communityScore(@Param("communityScoreDto") CommunityScoreDto communityScoreDto);
}
